package com.boot.generate.mysql;

/**
 * mysql对表列信息的一些查询语句
 *
 * @author 【zhouJie】
 */
public class SqlQuery {

    public static String tableSql(String tableName) {
        return "show table status where Name = \"" + tableName + "\"";
    }

    public static String tablesSql() {
        return "show table status";
    }

    public static String tableFieldsSql(String tableName) {
        return "show full fields from " + tableName;
    }

    public static String tableName() {
        return "Name";
    }

    public static String tableComment() {
        return "Comment";
    }

    public static String fieldName() {
        return "Field";
    }

    public static String fieldType() {
        return "Type";
    }

    public static String fieldComment() {
        return "Comment";
    }

    public static String fieldKey() {
        return "Key";
    }

    public static boolean isKeyIdentity(String Key) {
        return "PRI".equalsIgnoreCase(Key);
    }

}
